﻿CREATE PROCEDURE [acms].[Page_GetAllByRoot]
	@SiteId int 
AS
	SELECT *
	FROM [acms].[Page_View]
	Where [acms].[Page_View].[SiteId] = @SiteId
		and [acms].[Page_View].[ParentId] is null
RETURN 0;